10.1007@978-1-4842-2370-3 by Unknown

Author:Unknown
Language: eng
Format: epub

Chapter 5 ■ advanCed Querying

Figure 5-4. Full Join

Syntax:

SELECT t1.column1, t2.column2...

FROM table1 t1

FULL JOIN table2 t2

ON t1.column = t2.column;

0: jdbc:phoenix:localhost:2181:/hbase> SELECT O.ORDER_ID, C.FNAME, C.LNAME, O.ORDER_DATE FROM ORDERS O FULL OUTER JOIN CUSTOMER C ON O.CUST_ID = C.CUST_ID; 0: jdbc:phoenix:localhost:2181:/hbase> SELECT O.ORDER_ID, C.FNAME, C.LNAME, O.ORDER_DATE FROM ORDERS O FULL JOIN CUSTOMER C ON O.CUST_ID = C.CUST_ID;

5.4 Grouped Joins

Group joins, also known as subjoins, are complex nested join queries. Phoenix has support of group join for handling complex joins. These joins are normally applied on outer and inner joins where inner query joins results further as nested query joins.

Here one thing is to be noted about phoenix nested joins, they are always surrounded by parenthesis in query.

67

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.